9 - The Relational Model and Relational Algebra Skill Builders

Question 1

Write relational algebra statements for the following queries:

1. Report a firm's name and dividend.

Answer

shr [shrfirm, shrdiv]

Answer

 shr [shrfirm] where shrqty > 10000

Question 2

2. Find the names of firms where the holding is greater than 10,000.